
Import and combine multiple CSV files from a folder in Power BI, transform data with Power Query, split product into product and location, and load the model.
Normalize the model by creating a location lookup table from the sales prep query, referencing the source, removing duplicates, and adding an index column for fast Power BI queries.
learn how to mark a table as a date table in Power BI by selecting the date column in data view and confirming with OK.
Table of Contents/Timestamps
0:00 How to Use Excel Dark Mode
2:90 Using the Accounting Number Format Excel
7:45 How to Split Cells in Excel
11:19 How to Group Worksheets in Excel
13:50 How to Add Error Bars in Excel
17:53 How to Indent in Excel
21:28 Excel Format Painter - How to use it
26:02 How to Insert Checkboxes in Excel
34:27 How to Fix the Spill Error in Excel
38:27 How to Lock Cells in Excel
Table of Contents/Timestamps
0:00 How to Record a Macro in Excel
6:28 How to Delete a Named Range in Excel
10:39 How to Insert a Page Break in Excel
13:56 How to Fix Missing Scrollbar in Excel
17:26 How to Insert a Heat map in Excel
21:07 How to Fix the Name Error in Excel
26:18 How to Move Rows and Columns in Excel
30:06 How to Remove Space in Excel
32:52 How to Add Bullet Points in Excel
37:20 How to Make a Pie Chart in Excel
Ten Excel Tips and Tricks - Part 3 – Bonus
0:00 Freeze Rows in Excel
2:09 How to Convert Microsoft Excel to Word
5:23 How to Stop Excel rom Rounding
8:45 How to Calculate SUBTOTAL in Excel
12:02 How to Add an Excel Slicer
15:40 How to Graph a Function in Excel
19:42 How to Convert Text to Number in Excel
23:35 How to Copy Visible Cells Only
29:02 How to Add a Secondary Axis in Excel
37:32 How to Select Non-Adjacent Cells in Excel
**This course includes practice exercise files and LIFETIME access**
Learn Microsoft Power BI with this brilliant beginner course from Microsoft experts Simon Sez IT.
Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. It is the perfect Business Intelligence tool for people with limited technical experience.
In this Power BI course, we start by looking at Power Query, and how to use this tool to organize and clean our data. We then show you how to build a Data Model and relate separate tables. After that, we teach you all about the data analysis language DAX in Power BI. Finally, we look at how to present this data using the charts and graphs available.
In this course you will learn:
What is Power BI and why you should be using it.
To import CSV and Excel files into Power BI Desktop.
How to use Merge Queries to fetch data from other queries.
How to create relationships between the different tables of the data model.
All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.
All about using the card visual to create summary information.
How to use other visuals such as clustered column charts, maps, and trend graphs.
How to use Slicers to filter your reports.
How to use themes to format your reports quickly and consistently.
How to edit the interactions between your visualizations and filter at visualization, page, and report level.
***Exercise and demo files included***
This course includes:
4+ hours of video tutorials
45 individual video lectures
Exercise files to practice what you learned
Certificate of completion
Here’s what our students are saying…
"Brilliant course. I'm quite new to the world of POWER and this course has shown me what it can do in a way that a newbie can understand. Recommended. I will be looking for other courses by them."
- Andrew
"Very detailed course, really enjoyed the Power BI course. Simon has done a really good job explaining each process step. Looking forward to completing additional Power BI courses for advanced techniques."
- Martin
"I would highly recommend. The course was informative and easy to follow."
- Thomas
"Great match! Learning so much and I love the quick step by step videos."
- Vikki