The Complete Power BI Practical Course 2020
- 7.5 hours on-demand video
- 5 articles
- 42 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- How to create data models inside Power BI
- Get a good solid understanding of DAX
- How to build beautiful and interactive dashboards that can be presented to clients
- How to shape your data to meet the needs of the business
- Get a full exposure of the dashboard creation and sharing process
- A computer, both Windows and Mac users are welcome
Learn how to work with Power BI the practical way!
This course is designed for students who like to learn by doing.
Packed with real-life business scenarios along with quizzes and projects to build, this course will give you the solid understanding required to jump start your career as Power BI developer.
We will not only teach you how to create stunning dashboards, but we will also introduce you to data modelling, data transformations, teach you how to write DAX, set up calculated columns and measures, generate roles, and of course share your dashboards with your team or clients.
Power BI allows you to connect to hundreds of data sources and quickly analyse your data for free. And, although Power BI desktop may not be available for Mac, this course will show you an easy solution that allows you to use Power BI desktop on your Mac for free for the next 12 months!
This course is suitable for complete beginners, intermediate and advanced users, as we’ll guide you every step of your journey with easy to understand explanations.
Click 'Buy now' and start your Power BI journey today!
- Power BI beginners
- Power BI advanced users
- People interested in a career in business intelligence
Please create a model inside Power BI, data can be found inside Project Files -> 1. Data Extracts -> Section Three Data Extract. All tables need to be imported.
Create a dim_Date table using the ShipDate from fact_InternetSales and create the following columns inside:
Connect the dim_Date table with fact_InternetSales on ShipDate
Create the following visuals using the Ask a Question option:
Sales Amount by Currency, sorted by currency name
*Sales Amount by Month - sort it by the correct Month Order, not alphabetical order
Matrix Table to show Sales Amount by Email Address per Currency
BONUS POINTS if you can figure out how to increase the font size of the visuals on Titles, Values and Axis, and also change the Style of the Matrix table
Your task is to create a dashboard that looks aesthetically pleasing. Files can be located in Section Five Data Extracts, please import all columns from the excel file.
The dashboard should contain:
Header, background color to be #101D42
Slicer with Colors from dim_Product, to be placed inside the Header
Measures table (using DAX) with measures for Products Sold, Total Customers, Total Sales Amount
Three boxes to show Total Sales Amount, Products Sold and Amount of Customers. Each box should have the same background color as the Header, and also contain an image (images can be found in 5.Report Designer - 3. Icons). The values need to be shown inside the card visual. Boxes, images and values need to be aligned accordingly, values’ font size should be increased.
Two boxes with the same background color as Header. The first box should contain a donut chart showing the split between Male and Female, switch off the title from the donut chart and use Text Box. The text inside Text Box should say “Total Products Sold Male/Female Split”, font size to be bold, 24px, color to be #DB162F . Donut labels should be increased to 14 px. The donut colors should be white 20% Darker for Male and for Female use #DB162F. The second box should have a title called “Total Products Sold by Country”, same font size and color settings as the first box. Total products sold by country should be displayed using a bar chart. Title should be switched off from the bar chart, font size should be increased on both y and x axis.
Import all five tables from the Excel File called “Section Six Data Extract” into Power Query Mode
Create “Username” column inside dim_Customer table from the email address column. We are only looking for the text before the “@” symbol. The column should also be labeled “Username”
Scan the dim_Customer table and look out for columns with lots of Null values and remove them from the table
Import the tables into the model and check the connections between tables, make sure that every table is connected
Create #Measures table using DAX
Create dim_Date table using “fact_InternetSales[ShipDate]” column and create the following columns “Year”, “Month”, “Month Name”, “Day of Week”, “Quarter”, “Year/Quarter”. Make sure that the Month column is sorted correctly
Dynamic measure for selected currency, based on the selected currency the measure should return the sales amount in the selected currency, if no currency has been selected the measure should say “No currency selected”.
Dynamic measure for title that should say “Sales Amount in [Selected Currency] vs All Currencies“, alternatively it should say “Please Select Currency from the Dropdown Menu”
Create measures for Previous One Month, Previous Three Months and Previous Six Months
Measure that will tell us the time the report was last opened, text should say “Executed: Date and Time”
Header (background color optional) with line color #e8d400
Insert logo (located inside 3.Images) inside the header and resize it accordingly
Create buttons for “Clear Filters” (apply red outline on this button only), “Users” (apply outline using color #e8d400 on the rest of the buttons), “Currency”, “Sales Territory”. Buttons need to be positioned inside the header
Executed Measure to be placed inside the header on the right using Card Visual and resized accordingly, text should be on one line.
Create dropdown menus using bookmarks for Users, Currency and Sales Territory. The dropdown menus should have outline color of #e8d400 and an arrow pointing up to close the menu(arrow can be located inside 3.Images). Each of the dropdowns should contain the option to search inside the filter.
Create a bookmark that clears all the filters and apply it to “Clear Filters” button
Import Timeline Slicer into the visualisations panel. The visual can be located inside 4.Custom Visual. The slicer should be positioned below the header. Change the selected cells color to #e8d400
Create three boxes – first one to show Sales Amount in Selected Currency, second one to show Sales Amount for All Currencies in Previous Month, Sales Amount for All Time for All Currencies. Each box should have the same outline color of #e8d400. Text should be aligned in the middle, font size to be increased based on user preference. Sales Amount for Last Month and Sales Amount for All Time should not be filtered when choosing currency or region from the Header menu.
*Find out how to Increase Canvas Size to 1720h x 1280w
Position the Dynamic Title Measure in the middle inside a card visual with appropriate font size.
Using Line and stacked column chart create a visual that shows all Sales Amount in All Currencies, split by month name. Bar color to be #293537. Font size to be increased accordingly. *Inside the chart we should show the selected currency from the dropdown menu as a dot. Marker size to be 10 pixels. The dot color should be #e8d400. The chart should also have a Legend. Legend to be positioned in Top Center. Data lables should be visible for the bars, but not for the dots. The visual should have a placeholder in the background with line color #e8d400
Additional Dynamic Title Measure to be created. This title should tell us Total Products sold in the selected country or alternatively Total Products Sold Worldwide. This should be triggered by the Sales Territory Dropdown button from the Header
Number of Products Sold by Country to be shown inside a map visual. Change the color of the country to #e8d400. The visual should have a placeholder in the background with line color #e8d400
Create a table that shows the SalesTerritory along with the Sales Amount as %, Total Sales Amount, Sales for Previous One Month, Previous Three Months, Previous Six Months. Font size to be increased accordingly, outline to be removed. Column headers to be colored in #e8d400. Totals should have the same background color as per headers. Remove the outline from Totals as well. SalesTerritoryCountry background color to be changed to the same color as Totals. All headers should be capitalised. Apply conditional formatting to the Total Sales Amount %. If values are between 0 and less than or equal to 0.2 make it red, if it is greater than or equal to 0.3 and less than 0.5, make it #e8d400, if it is greater than or equal to 0.5 and less than or equal to 1, make it green
Test out the dashboard, make sure that everything works in sync. Bonus points if you can figure out how to change the boxes inside the Currency dropdown from a box to “Single Select” so that users can only choose one Currency from the dropdown menu at a time.