Data Analytics Course - Heels and Tech

Data Analytics Course

Whether you are an HR professional, a medical lab scientists, a researcher or a business owner you can determine different ways through which you can make good strides to achieve positive results in your line of profession by utilizing and optimizing your Data.

Understanding how to visualize data shows you how to make sense of your data, present clear evidence of your findings, and tell engaging stories all through data graphics.

COURSE FEE

NGN 150,000/USD 300

REGISTER FOR THIS COURSE

What You’ll Learn

You will discover the concepts of data analytics, the role of a data analyst, and the tools that are used to perform daily functions.
You will gain understanding of the data ecosystem and the fundamentals of data analytics, such as data gathering & data mining.
You will then learn the soft skills that are required to effectively communicate your data to stakeholders, and how mastering these skills can give you the option to become a data driven decision maker.
In addition you will learn how to clean, analyze, and share your data with the use of visualizations and dashboard tools.
By the end of this course you will be able to carry out data process, present your data using graphics, understand the different career paths that are available for data analytics, and explore the many resources available for mastering this profession.

Course Outline

Prepare The Data

Get Data From Different Data Sources

Identify and connect to a data source
Change data source settings
Select a shared dataset or create a local dataset
Select a storage mode
Choose an appropriate query type
Identify query performance issues
Use Microsoft data verse
Use parameters
Use or create a PBIDS file use or create a data flow
Connect to a dataset using the XMLA endpoint

Profile The Data

Identify data anomalies
Examine data structures
Interrogate column properties
Interrogate data statistics

Clean, Transform, And Load The Data

Resolve inconsistencies, unexpected or null values, and data quality issues
Apply user-friendly value replacements
Identify and create appropriate keys for joins
Evaluate and transform column data types
Apply data shape transformations to table structures
Combine queries
Apply user-friendly naming conventions to columns and queries
Leverage advanced editor to modify Power Query M code
Configure data loading
Resolve data import errors

Model The Data

Design A Data Model

Define the tables
Configure table and column properties
Define quick measures
Flatten out a parent-child hierarchy
Define role-playing dimensions
Define a relationship’s cardinality and cross-filter direction
Design the data model to meet performance requirements
Resolve many-to-many relationships
Create a common date table
Define the appropriate level of data granularity

Develop A Data Model

Apply cross-filter direction and security filtering
Create calculated tables
Create hierarchies
Create calculated columns implement row-level security roles
Set up the Q&A feature

Create Measures By Using DAX

Use DAX to build complex measures
Use CALCULATE to manipulate filters
Implement Time Intelligence using DAX
Replace numeric columns with measures
Use basic statistical functions to enhance data
Create semi-additive measures

Optimize Model Performance

Remove unnecessary rows and columns
Identify poorly performing measures, relationships, and visuals
Improve cardinality levels by changing data types
Improve cardinality levels through summarization
Create and manage aggregations

Visualize The Data

Create Reports

Add visualization items to reports
Choose an appropriate visualization type
Format and configure visualizations
Import a custom visual
Configure conditional formatting
Apply slicing and filtering
Add an R or Python Visual
Configure the report page
Design and configure for accessibility
Configure automatic page refresh
Create a paginated report

Create Dashboards

Set mobile view
Manage tiles on a dashboard
Add a dashboard theme pin a live report page to a dashboard configure data classification
Configure data alerts use the Q&A feature

Enrich Reports For Usability

Configure bookmarks
Create custom tooltips
Edit and configure interactions between visuals
Configure navigation for a report
Apply sorting
Configure sync slicers
Use the selection pane
Use drill through and cross filter
Drill down into data using interactive visuals
Export report data
Design reports for mobile devices

Analyze The Data

Enhance Reports To Expose Insights

Apply conditional formatting
Apply slicers and filters
Perform top N analysis
Explore statistical summary
Use the Q&A visual
Add a quick insights result to a report
Create reference lines by using analytics pane
Use the play axis feature of a visualization
Personalize visuals

Perform Advanced Analysis

Identify outliers
Conduct time series analysis
Use groupings and binnings
Use the key influencers to explore dimensional variances
Use the decomposition tree visual to break down a measure
Apply AI insights

Deploy and Maintain Deliverables

Manage Datasets

Configure a dataset scheduled refresh configure row-level security group membership
Providing access to datasets
Configure incremental refresh settings
Promote or certify Power BI datasets
Identify downstream dataset dependencies
Configure large dataset format

Create And Manage Workspaces

Create and configure a workspace
Recommend a development lifecycle strategy
Assign workspace roles
Configure and update a workspace app
Publish, import, or update assets in a workspace
Apply sensitivity labels to workspace content
Use deployment pipelines
Configure subscriptions
Promote or certify Power BI content

Watch one of our students create a beautiful dashboard while she makes sense out of data here.

Read the stories of our students and their experiences after taking our Data Analytics Course here.

REGISTER FOR THIS COURSE

Upcoming Cohort Intake

There are no upcoming events.

Benefits of Taking the Course

You will be able to analyze data from different data sources and create their own datasets.
You will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together
You will have the required knowledge to dive deeper into Power BI and find out more about its advanced features

Job Titles You Can Apply To As A Data Analyst

Business Intelligence Analyst
Data Analyst
Data Scientist
Data Engineer
Quantitative Analyst
Data Analytics Consultant
Operations Analyst
Marketing Analyst

View their Certifications

COURSE FEE

NGN 150,000/USD 300

Duration: 3 WEEKS
Time frame: MONDAYS – FRIDAYS (7PM – 9PM)
Overall Time frame: 60 hours
Course inclusion: How to use the tool, Hands-on project, Mentorship with industry experts and Examination preparations (Practice questions)

Free Webinars on Data Analytics You May Like to Watch

Microsoft Power BI

Watch Tutorials

Demo Session on Microsoft power BI

Watch Demo Session of Our Student Bukola

× Chat With Us on WhatsApp