|
 |
21Tech, LLC
1390 Market Street, Suite 1202
San Francisco, CA 94102
Phone: 1-415-355-9090
Fax: 1-415-355-9095
Contact contact@21tech.com
|
|
 |
Business Intelligence (Bl) |
|
|
Business Intelligence mines otherwise dormant information to effectively realize at all levels of a company the means to guide employees with a vision, stay on track, provide accountability, and exclude outliers to make informed and effective decisions. The base information used can include customer databases, supply chain information, personnel data, manufacturing, sales and marketing activity, as well as many other sources of information critical to your operation
BI Clients
- CCSF DPW, CCSF 311
- City of Indianapolis
- HRC
- COIT
- Mayor’s Office of Criminal Justice
- Dept. of Public Health
- Microsoft
BI Products
- IBM Cognos
- Microsoft SQL Services
- Informatica
- Oracle OBIEE
- Tableau
- MicroStrategy
|
|
BI Methodology |
|
|
| From C level officers on down, dashboards are highly effective ways to monitor and view complex aggregated information, and spot discrepancies as they occur. Security constraints allow different views of data – from web based to hand held phones, GIS integrated to dynamic interactive dashboards. |
| |
 |
|
|
|
BI Dashboards and Scorecards |
|
|
| From C level officers on down, dashboards are highly effective ways to monitor and view complex aggregated information, and spot discrepancies as they occur. Security constraints allow different views of data – from web based to hand held phones, GIS integrated to dynamic interactive dashboards. |
| |
 |
| |
| Access to easy-to-use scorecards will align your tactics with your strategy, communicate business goals company-wide and allow people to monitor performance against their targets. |
| |
 |
|
|
|
Data Warehousing |
|
|
Data Warehousing projects are typically complex and resource intensive. The nature of pulling data from disparate sources, aligning the data and merging into a reportable format can be a challenge. It not only requires expertise with the technology but an ability to align the information to meet long-term business needs. Once the data is integrated, the benefits of being able to report and act on the information in a timely manner are tremendous. A few of the key factors in a successful warehousing solution are:
1) Expert Advisory Service
Partner with the right team that bring significant knowledge and creativity to managing on past key learnings. Presenting data as information is often subjective, it’s important to work with a team that has a grasp of your vision and able to bring the experience to enable your vision.
2) Planning
Understand your business goals. What information is needed to operate the business day to day and to meet long-term goals. Transforming data into information isn’t as simple as simply as loading and combining the data.
3) Understand Users
Understand user day to day and long-term needs. Work with users so their needs are identified upfront. Partner with subject matter experts to take advantage of synergies between different users and groups.
4) Integration
A key component is the ability to extract data from disparate applications which are usually a combination of home grown applications and solutions obtained from vendors. The Data Warehouse will act as the central data point to your suite of applications.
5) Technology Selection
These days there are many Relational Database Management System (DBMS) based solutions from vendors like Oracle, IBM, Microsoft, HP, NetApp and open source databases, like mySQL. Many factors such as performance, cost (implementation and maintenance), time to market need to be considered while selecting the right solution. |
| |
|
|
|
