Hello Readers and fellow Perficient bloggers,
This is my first official blog post on Business Intelligence forum. Before I tell you what my blog is about and the agenda for upcoming blog posts, I would like to give you a quick introduction.
I am Sujay Nadkarni and I joined Perficient in March 2012 as a Business Consultant after completing my Master’s Degree in Information Systems from University of Texas, Dallas. I am a Sun Certified Java Developer, Certified Scrum Master and have a certification in SAS. Besides technology, I love soccer. I am probably the biggest Juventus FC fan on this planet and my dream is to watch at least one Juventus home game. I also love traveling and that is primarily the reason I joined Perficient (kidding). Italy, Machu Pichu and Bora Bora are on the list of places I would love to visit before I die. As a kid, I also acted in several Bollywood movies and Television series.
I am confident that everyone knows the importance of data in today’s world and the importance of presenting meaningful data to our clients.
Petabytes and Terabytes of data are collected every day from millions of users. Check out this interesting link
It has become important to analyze this data and try to make sense out of it. I intend to write several short posts on several business intelligence tools and I hope these posts will prove to be immensely helpful to consultants.
I am going to start with Microsoft’s SSRS tool (SQL Server Reporting Services) and then cover other tools such as SSIS, R, SAS, etc. This tool is particularly helpful in creating tabular reports, pie charts, line charts, sub reports from the plethora of data stored in the databases.
Agenda:
1.) Creating First Report
2.) Customizing Report and making report presentable.
3.) Creating a Pie Chart Report
4.) Creating Graph Reports
5.) Parameterized Reports.
6.) Displaying Monthly Data.
7.) Sorting Data.
8.) Moving Averages and other calculated fields.
9.) Multi tabbed report.
I hope you are as excited to learn about new BI tools as I am talking about them. I hope you will stay tuned to my blog posts. Please feel free to comment below or connect with me on Linkedin.