‘E Reporting Services by EReporting.net’ Archives
Freelance Crystal Reports Consulting by Kaleem
Our mission is to deliver solutions that empower our clients to make decisions that maximize performance -- we specialize in transforming business data into actionable information through proven Crystal Reports consulting services. By combining our experience in technology, business and industry best practices, We are well-positioned to deliver [...]
Consultant – Data Analyst, Sql server Programmer, Crystal Reports and SSRS Developer, Report writer and Report Designer
Crystal Reports, SSRS, SQL Programmer, DataAnalyst Mian Kaleem, I am based in Toronto, GTA, but i work all over USA and Canada. I have completed projects on writing, designing and developing Crystal Reports, , Sql Reporting Services writing, in New York, Detroit, Toronto, GTA and Dubai on Consultancy/ IT Contractor / Freelance [...]
Star Schema – Fact table a closer look
In this post we are writing more on factt table in star schema because we believe that clear concept of fact table and its creation is critical to understand the difference between OLTP Relational Database’s logical model and then its de-normalization to create Star schema, which have fact table in the centre. We found some useful writings [...]
Process From OLTP datamodel to Olap DataModel
This present s an example showing the process to denormalization for dataware house or data mart Star schema. We researched on this topic in various books and even Microsoft examples they only give sample, but we think it is more important to know how oltp data model is converted in Star schema or olap. We used Microsoft’s Northwind data [...]
Best tool for Dynamic Website – CMS
So far we have tried many dynmic web softwares which are also known Content Management System. They run on top of database or inother words all the information is saved in database. we used ASP classic and SQL Server 2000 database and had our hand wet with vb scripting, it was in the late 90s and early 2000. then microsoft used asp.net. Then we [...]
As BI Consultant and Data Analyst – Gateway Laptop Rocks – HP-Toshiba Sucks
We would like to share our experiance of using Laptops from Gatway, HP and Toshiba. As a database and BI consultant Laptop is like my tool to write, present and design just like a pen is to an author. Over the years of experiance in using laptops for my professional career I found Gateway the best, whereas HP and Toshiba I would sad to say Sucks. [...]
key not valid for use in specified state in SSAS 2008
I recently faced this issue which deploying a Sql Server Analysis Project 2008, however was able to resolve by doing the following; I did, go to services, change the SSAS service to use the local / admin account. this error will then vanish.
Quality Control
Quality Control - (a) Planned systematic activities necessary to ensure that media conforms to established technical requirements. (b) All actions that are taken to ensure development of products that meet performance requirements and adhere to standards and procedures. (c) Policy, procedures and systematic actions established in an enterprise for [...]
Data Quality Strategy – SQL Server Technical Article
This post ic about Data quality which always done in every organization it is presented here in more formal words: Primary goal of a data integration solution is to assemble data from one or more data sources. As you bring data together, you are likely to find a broad range of data quality issues that require attention. For example, you may [...]
Sample: Specific Job Skills for data analyst
Database professionals like sql developer, reporting analysts in Crystal Reports, Sql Reporting services and sql programmers can enter into new promising field of healthcare data analysts by following the job descriptions in this field. Following is the sample job description from - The Washington State Hospital Association (WSHA) published on [...]
