Becoming a BI Reporting Specialist is anyone's dream who wishes to combine coding and design and also has a passion for databases.
This course is designed to teach you everything that you need to know to become one of them.
You're going to start by creating basic reports and work your way up to more complex ones, by example.
No boring talks about concepts and theoretical stuff. Consider this a workshop in which you will actually see how things work and what a Reporting Specialist does daily.
I work as a BI/DB Developer myself and I love what I do. Give me a chance to show you how things work in my world and maybe you will start loving this as much as I do.
Can't wait to see you among my other students soon!
Good to know:
A short description and introduction to the course and SSRS reports
Overview on what the main areas of interest are in Data Tools
What is a dataset and how to create one
How to add a table to your report and display data in it.
Some simple formatting, very much the same way as any Office app text formatting.
how to add a page header and footer and display text in it.
Conclusions on first part of the course
Learn how to quickly create a report being guided step by step using the wizard.
In this lecture we are going to explore Cascading Parameters. How you can control the available values of one parameter based on the selection you made on a previous parameter.
What is and how to work with a Shared Data Source
What is and how to work with a Shared Data Set
Subreports are widely used in dashboards but first we need to learn how to create and use one.
Learn how to add and customize an image in SSRS. Also look at some of the proprieties and actions that an image can have.
Expressions are a very useful way of conditioning behaviours in Data Tools Reports. This is a brief introduction to Expressions.
Learn how to write an expression that alters background color of your table based on a condition.
Learn how to write an expression that alters the color of your text based on a condition.
Show or hide elements of your report using an expression.
What is a matrix , how to use it and how is it different from a table.
There is no report without a chart right? Here's how you add one to your SSRS report.
Even if your report looks good in the Preview mode, when exporting it things become a bit tricky. Here are some hints that are worth considering when optimizing your report for export.
Insert page number, report tile and more using built in fields.
After you upload your reports you need to connect them to a data source. Here's how to do it.
I am a young but experienced and highly passionate BI Reporting Specialist and Database Developer,writer and founder of EasyWaySQL and MyCar mobile app.
I also have a Bachelor's degree in Business Administration and a Master's degree in Economic Decision Support Systems.
Other than that I am dedicated to share my knowledge with others and learn new technologies on the way.