Category: NON SQL

Power BI Dashboard Report

Overview:-

Power BI is a dashboard reporting tool, also an user friendly tool which can get inputs from various data sources (SQL Server, excel, csv, analysis services and text files) and generate a graphical and meaningful dashboards. In general

Report – is a single visual representation

Dashboard – is a two or more reports/visuals together in same page

Power BI Desktop has 3 tabs mainly Reports, Data and Model (as shown below)

i) Model – is a data source view diagram to view all imported tables objects from any one of the input data sources

ii) Data – place where you can preview the sample data of the imported table objects

iii) Reports – for creating dashboards/reports from the model table objects

Following are the other tabs which are used to support the Model, Data and Reports tab

  1. Data Sources – used to get the Input data for Dashboards/Reports
  2. Visualization – used to show the data in more readable and understandable formats
  3. Fields – contains the table objects along with Measures (names) and Values (sales, score)
  4. Filters – used to filter data on page level or visual level

Below is the sample SQL data consists of 3 tables which has employee’s Mathsmark, Interest and Sales data. Execute this script in your SQL Server Management Studio before start creating Power BI dashboard, it acts as a Data input for Power BI Dashboard.

Create Database Power_BI
GO

---Employee's Mathsmark---
drop table if exists Mathsmark
create table Mathsmark(
	EmpName Nvarchar(1000),
	Score Int
)
Insert into Mathsmark (EmpName,Score) 
values ('John',50),('Mac',35),('Lion',70),('Tiger',62),('Pigeon',23),('Alex',92),('Jack',84)

---Employee's Interest---
drop table if exists Interest
create table Interest(
	EmpName Nvarchar(1000),
	Games Nvarchar(1000)
)
Insert into Interest (EmpName,Games) 
values ('John','Cricket'),('Mac','Football'),('Lion','Hockey'),('Tiger','Football'),('Pigeon','Cricket'),('Alex','Chess'),('Jack','Football')

---Employee's Sales---
drop table if exists Sales
create table Sales(
	EmpName Nvarchar(1000),
	SalesNo Int
)
Insert into Sales (EmpName, SalesNo)
values ('John',550),('Mac',305),('Lion',730),('Tig
er',610),('Pigeon',260),('Alex',950),('Jack',870)

In this blog, we will see how to create Power BI dashboard with Line Chart, Pie Chart, Stacked Column Chart, Matrix, Table and Donut Chart, Let’s see step by step procedure for creating the Dashboard.

Step 1:- Importing of SQL Data to Power BI Desktop, select “SQL Server” from “Data” tab and give your Servername and Database as “Power_BI” and click “OK”

Step 2:- Check all 3 table check boxes and click “Load”, you can also view the preview data by selecting the table object

After clicking the “Load” button, you can view the data model of “Power_BI” database in the “Model” tab, objects relationship are created automatically by the Power BI tool, all the table objects fields in displayed in right side “Fields” tab

You can also view table’s preview data and objects names, fields in “Data” tab

Step 3:- Select “Line Chart” in Visualizations tab and check the fields in “Mathsmark” table and also sort the line chart by “EmpName” field

Step 4:- Select “Pie Chart” in Visualizations tab and check the “Games” fields in “Interest” table and drag “EmpName” field to values tab, it will display the no. of employees interested in which games

Step 5:- select “Stacked Column Chart” in Visualizations tab and check “Sales” table fields, as mentioned in above here I’ve sorted the data by “EmpName” Field

Step 6:- select “Matrix” in Visualizations tab and check the fields (EmpName, Score and SalesNo)

Step 7:- select “Table” in Visualizations tab and check the fields (EmpName and Games) from “Interest” table

Step 8:- select “Donut Chart” in Visualizations tab and check the “EmpName” field from “Interest” table and “SalesNo” field from “Sales” table

Now we will see how to filter data in dashboards/reports, in Power BI we have 3 level of filtering (Report/Visual, Page and All Page), please note that the report/visual level filter will appear only after selecting page level filter.

here we have used the page level filter in which (EmpName =”Jack”) is excluded, now the dashboard is showing all Employee’s data expect “Jack”

Happy Learning !! Please share it with your friends If you like this post.

Power BI Desktop Installation Guide

Overview:-

Power BI is a dashboard reporting tool which uses the various data sources (SQL Server, excel, csv, analysis services and text files) as input for reports/dashboards.

Benefits of Power BI:-

  1. Dashboard Reporting
  2. Easy and User Friendly
  3. Minimal Coding and no technical expertise is required
  4. Can use wide variety of data source
  5. Cloud Reporting (so you can access reports in mobiles)

You can download the Power BI Desktop setup file (PBIDesktopSetup_x64.exe) from any one of the below links,

https://powerbi.microsoft.com/en-us/downloads/
https://www.microsoft.com/en-us/download/details.aspx?id=58494

Power BI Installation Procedure:-

Step 1:- Double click the “PBIDesktopSetup_x64.exe” Setup file and Select Language and then click “Next”

Step 2:- Click “Next”

Step 3:- Accept the Terms and click “Next”

Step 4:- Change the default Installation Drive (If needed) and then click “Next”

Step 5:- Check the checkbox (if you need a desktop shortcut) and click “Install”

Step 6:- Installation is in progress, please wait for it to complete

Step 7:- Check the “Launch” checkbox and click “Finish”

Power BI Desktop will Appear, now you have successfully installed the Power BI Desktop in your Machine.

Happy Learning, To Explore and Create your first Power BI Dashboard, Please click here

How to Automatically Post to Facebook From WordPress

I was wondering if there are any automatic way of posting my blog post to Facebook directly from WordPress as it gets published. I found several ways, as one of my first google search was pointing to a page- https://blog.hubspot.com/website/automatically-post-facebook-wordpress. Its quite good one and describes few methods. However, I was not still convinced to believe there are no way and surfaced the wordpress menu bars multiple times.

Finally, I managed to get a way to do as below. Not sure if there are any other better way around, I would appreciate if there are any simpler way than this.

Go to “My Sites” -> Tools -> Marketing -> Connections

Another way is to provide “Sharing Buttons” in your blog post. But I feel the above one is quite easy and it works out for me well. I do not think to go for any plugins to do this job, this makes life easier for many bloggers like me.

Looking forward your thoughts and requesting you to share if there are any other better or alternatives.

Some thoughts on working from home and remote work

“Work from Home” – A new IT norm in India. Before I jot down my views here, let me clarify, its my personal views, you may or may not agree to all, but good if you can share your thoughts in the comments section.

So, a new norm, Initially, I was not thinking Indian IT would adopt this so fast we are now for various reasons like intermittent network issues, unavailability of network at remote places and other logistics. But, CORONA the real game changer made it all happen so quickly. I would personally think we travelled at least 5 years ahead than we could have been if the pandemic had not been come into our life. Anyway, few things are positives, but lots of negatives like our normal life has impacted a lot like street shop businesses (one of the major business in India), hospitality, travel etc. A mood of despondency had set in many people. However, am taken aback to see our ability and tenacity to fight back with CORONA as well as the challenges due to that. As we started working from home, we also had lots of changes in our life styles. Now, there are few things, which I wanted to share with you all, very important for all of us, thought its not late yet. Here we go…

1. Our posture is our future
It is important to keep a good posture at work. People tend to take their comfort with different method, sitting on bed, lying down or any other awkward ways. But, it is very important that we should follow the right postures for a long run. Desk ergonomic is important to be followed as this work from home extends to more months.
https://www.computer-posture.co.uk/good-computer-posture/

2. Exercise to live healthy
“Good things come to those who sweat.” – It has everything. You may not be able to go to your regular gym, but make sure you continue your walk.

Here are few suugestions:

Yoga
Squats
Jogging on the spot
Plank
Push ups
Skipping rope

https://thewaryworker.com/work-from-home-exercises/

3. Right food at right time
Being at home, the big negative is our food intake. We work along with family, they would supply lots of food to make us energetic, but be aware, those are not really good for our health. Have food for our thoughts not for body (too much). Try to shift from junk to healthy. Avoid dry snacks/chips etc. Staying hydrated is equally important having food at time.

https://medicalxpress.com/news/2020-04-lockdown-opportunity-food-habits-good.html

4. Shift ear-in headphones to ear-on/over headphones
Important guys, I am a victim of it. Switch immediately from ear-in to ear-on headphones. My doctor advised me to do this shift for everyone including kids. Now, kids have online classes and they spend more time with head phones. If you still use ear-in then change to ear-on ones. The later causes lots of fungal issues in your ears and it will lead to a very bad pain in your ears. So, take swift action!

https://www.hearing-speechcenter.com/ear-pain-earphones/

5. Take leaves and clean leaves around you
Now days, no celebrations/marriage functions etc. So you will have many leaves in credit. I would recommend to take the leaves to spend with your family. I used to go to my backyard with my family and clean the area on those days. Good for health and thoughts. Its always good to stick to the office time as you were in office. We may tend to extend our office hours naturally, but we need to be aware when to close the business hour and involve with rest of the world. 🙂

Hope this helps you also, share your thoughts. Stay home stay healthy!

I’d like to grow my readership. If you enjoyed this blog post, please share it with your friends!

Zoomit – A tool to boost your presentation skills

If you are community player or even you want to present something to someone, you may need to zoom in and zoom out certain area of your presentations to make the audience clear about your key areas. I always find it difficult if I share a screen with someone on explaining things and showing it to them. Power point presentation has an option to zoom-in and zoom-out, however, this cannot be applied for other software like SSMS etc. Today, let us quickly see some of the options that could help us in similar situations.

There is a default option in SSMS to zoom out, however, its applicable for only Query part as below:

If you need something for results or any other area, then there is no default way of achieving in SSMS. To support in such situation, I would like to introduce a tool called Zoomit by Microsoft. You can download the tool from the below link:

https://docs.microsoft.com/en-us/sysinternals/downloads/zoomit

You can explore this tool and share your thoughts. If you are already using any other tools, please share the details, happy to explore and play with it. Looking forward your comments.

I’d like to grow my readership. If you enjoyed this blog post, please share it with your friends!