Loved by learners at thousands of companies
Gain a 360° overview of how to explore and use Power BI to build impactful reports. In this course, you’ll go from zero to hero, as you discover how to use this popular business intelligence platform through hands-on exercises. You’ll first learn how to confidently load and transform data using Power Query and the importance of data models, before diving into creating visualizations using Power BI’s drag-and-drop functionality. You’ll also learn how to drill-down into reports and make your reports fully interactive. Lastly, you'll level-up your skills using DAX formulas (Data Analysis Expressions) to create customized calculated columns and fields to better analyze your data. Get started now. You've got the power!
Getting Started with Power BIFree
Discover how to navigate this intuitive tool and get to grips with Power BI’s Data, Model, and Report views. You’ll load multiple datasets in the Data view, build a data model to understand the relationships between your tables in Model view, and create your first bar graph and interactive map visualization in Report view. You’ll also practice using Power Query Editor to prep your data for analysis.Introduction to Power BI50 xpFeatures of Power BI50 xpGetting started!50 xpLoading existing reports100 xpYour first visualization100 xpAdd a card100 xpSlicers and Tables50 xpSlicers100 xpMore columns100 xpTable100 xpTransforming data50 xpCleaning data50 xpPower Query Editor50 xpTransform before load100 xpField aggregation100 xpTransforming and formatting columns50 xpTransforming columns100 xpFormatting currency100 xpMaking maps with geographic data100 xp
It’s time to power-up your business intelligence skills! Through hands-on exercises, you’ll learn how to change and format a wide range of visualizations, before moving on to sorting data and creating hierarchies—making it possible for you to drill into your reports. Lastly, you’ll discover how to filter the information in your reports by location and control how these filters interconnect and interact with other visuals in your report.Visualization options50 xpChoosing the right visual50 xpMaking changes50 xpChanging visuals100 xpEditing properties100 xpSorting and more formatting50 xpSorting data100 xpUsing the slicer100 xpMaking it look good100 xpDrilling down and filtering50 xpWorking with hierarchies50 xpThe underlying data and hierarchies50 xpLooking at the data100 xpCreating a hierarchy100 xpFilters50 xpAdding a filter100 xpTurning off interactions100 xpApplying advanced filtering100 xp
Creating Calculations with DAX
In this chapter, you’ll learn how to create customized calculations using Microsoft's formula language, DAX (Data Analysis Expressions). Very similar to how formulas are written in Excel, you'll learn how to create calculated columns and tables—and when you should use them. You'll then progress to writing powerful calculated measures, leveraging Power BI's Quick Measures, to create complex DAX calculations like year over year change.Introduction to DAX50 xpCalculated tables and columns50 xpGenerating passwords100 xpNested function100 xpProfit column100 xpCalculated measures50 xpAverage function100 xpProduct count100 xpProfit margin ratio100 xpCalculated measures and Quick Measures50 xpCalculate function and Quick Measures50 xpCalculate function100 xpYour first Quick Measure100 xpTime-based calculations50 xpCALCULATE() and dates100 xpPrior year profits100 xpQuarter over quarter change100 xpCongratulations!50 xp
Curriculum Manager at DataCamp
Sara is a graduate of a master's degree in Business Engineering and Marketing Analysis. Prior to working at DataCamp she worked as a Data Science consultant for a Belgian IT company. Sara is passionate about education, data science, and business and loves that she is able to combine all of these disciplines in her job as curriculum manager at DataCamp.
Workspace Architect at DataCamp
Lis holds a Master's degree in Computer Science from McGill University with a focus on computer science education research and applied machine learning. She's passionate about teaching all things related to data and improving the accessibility of these topics.
What do other learners have to say?
“I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.”
Devon Edwards Joseph
Lloyds Banking Group
“DataCamp is the top resource I recommend for learning data science.”
Harvard Business School
“DataCamp is by far my favorite website to learn from.”
Decision Science Analytics, USAA