This portfolio showcases my Power BI skills, which I developed through completing the Data Analyst in Power BI track on DataCamp. The track covers various topics, including importing, cleaning, manipulating, and visualizing data, as well as other Power BI functionalities such as data modeling, DAX, and Power Query. The courses provided me with a comprehensive understanding of Power BI, enabling me to create effective and insightful data visualizations.
- Data importing, data cleaning, data manipulation, and data visualization
- Data preparation, data transformation, and Data modeling.
- Power Query
- DAX functions
- Exploratory Data Analysis, and Trend Analysis
- Report Design
- Creating interactive dashboards
Course 1 Introduction to Power BI
Topic: Power BI features, transforming data, visualizing data, and filtering data.
Course 2 Introduction to DAX in Power BI
Topics: DAX, caculated column and measures, context in DAX formulas, DAX measures, date and time functions, and quick measures.
Course 3 Data Visualization in Power BI
Topics: Table and scatter charts, bar charts and small multiples, combining charts and custom visuals, shares, gauges, and KPIs.
Course 4 Case Study Analyzing Customer Churn in Power BI
Topics: Exploratory Analysis, investigating churn patterns, visualizing the analysis.
Course 5 Data Preparation in Power BI
Topics: Power Query, data preview features in Power Query, data manipultation, and text and numerical transformation.
Course 6 Data Transformation in Power BI
Topics: Reshaping and aggregating data, combining data, merging and appending queries, custom columns, Advance Editor, and M Language.
Course 7 Data Modeling in Power BI
Topics: Data modeling and table properties, loading and transforming data, shpaing tables, merging and appending queries, dimensional modeling, creating a star schema, star and snowflake schemas, and evaluating performance.
Course 8 Intermediate Data Modeling in Power BI
Topics: Date dimensions and relationships, glanularity, measures, hierarchies, working with relationships, cross-filtering, and role-playing dimensions, and identifying perfoemance problems.
Course 9 Case Study HR Analytics in Power BI
Topics: Data modeling and Exploratory Data Analysis, analyzing demoographics and performance, and creating report.
Course 10 DAX Functions in Power BI)
Topics: Setting up data models with DAX, Dax, and Measures, filtering and counting with DAX, and iterating functions.
Course 11 Intermediate DAX in Power BI)
Topics: Logical functions, row-level security, table manipulation functions, and time intelligence functions.
Course 12 User-Oriented Design in Power BI
Topics: Tracking focal points, malps and external scripts, designing for accessibility, automatic page refresh, Q&A visual, decompositions trees, and paginated reports.
Course 13 Exploratory Data Analysis in Power BI
Topics: Descriptive statistics, identifying missing data, applying imputation techniques, distributions and outliers, EDA with categorical variables, and relationships between continuous variables.
Course 14 Trend Analysis in Power BI
Topics: analyzing time series data, time series run chart, decompostition trees, and key influencers visuals.
Course 15 Reports in Power BI
Topics: The differences between reports and dashboards, increasing reports interaction, bookmarks, buttons, navigation, customize look and feel, mouse actions, unicode, and customize a report with Q&A visual.
Course 16 Report Design in Power BI
Topics: Enhancing visual and improving engagement with DAX, progressive disclosure, custom theme, and design for mobile devices
Course 17 Data Connections in Power BI
Topics: Data connections, database connections, data source settings, parameter and incremental refresh, and identifying data importing processes issues with M Language.
Course 18 Deploying and Maintaining Assets in Power BI
Topics: Workspaces and applications, creating workspaces and apps, securing content, and enabling users.